Import File Example
An import file can an activity file, resource file, or a combination of both.
This is an example of an activity import file.
1.1.1,1600,01,161,This is act 1,12/15/09,02/03/02
1.1.1,1600,02,162,This is act 2,02/09/02,03/30/0
This is an example of a resource file.
161,ENG1,156,12/15/09,12/31/09
161,ENG1,200,01/01/02,01/31/02
161,ENG1,10,02/01/02,02/03/02
161,ENG2,35,12/15/09,12/31/09
161,ENG2,40,01/01/02,01/15/02
162,TECH,206,02/01/02,02/28/02
162,TECH,290,03/01/02,03/30/02
162,MATL,10000,02/01/02,02/01/02
This is an example of a combined activity/resource import file.
1.1.1.1,1400,01,1.1.1.1.01,06/01/2007,07/12/2007,LABOR,100,10000
1.1.1.1,1400,02,1.1.1.1.02,06/01/2007,10/13/2007,MAT,0,100000
1.1.1.2,1420,01,1.1.1.2.01,09/01/2007,12/23/2007,LABOR,50,5000
If you are loading a forecast, you are loading forecast dates and forecasted resource requirements. Therefore, the resource requirements should not be before the status date. For example, if the project status date was 12/31/09, the following is an example of the resource import file:
161,ENG1,200,01/01/02,01/31/02
161,ENG1,10,02/01/02,02/03/02
161,ENG2,40,01/01/02,01/15/02
162,TECH,206,02/01/02,02/28/02
162,TECH,290,03/01/02,03/30/02
162,MATL,10000,02/01/02,02/01/02